데이터베이스 온라인 배달 앱 과제 소스코드 A+

목차

없음

본문내용

CREATE TABLE Members (
MemberID VARCHAR2(32) PRIMARY KEY,
Password VARCHAR2(64) NOT NULL,
PhoneNumber NUMBER(16) NOT NULL,
MemberType VARCHAR2(8) CHECK (MemberType IN (‘일반’, ‘사장’)) NOT NULL,
Email VARCHAR2(128),
AddressProvince VARCHAR2(32) NOT NULL,
AddressCity VARCHAR2(32) NOT NULL,
AddressDistrict VARCHAR2(32) NOT NULL,
AddressDetail VARCHAR2(128) NOT NULL,
CreationDate TIMESTAMP
);

CREATE TABLE Store (
StoreID NUMBER(9) PRIMARY KEY,
StoreName VARCHAR2(32) NOT NULL,
AddressProvince VARCHAR2(32) NOT NULL,
AddressCity VARCHAR2(32) NOT NULL,
AddressDistrict VARCHAR2(32) NOT NULL,
AddressDetail VARCHAR2(128) NOT NULL,
PhoneNumber NUMBER(16) NOT NULL,
Introduction VARCHAR2(255),
MinOrderCost NUMBER(8) NOT NULL,
TotalReviewCount NUMBER(8) DEFAULT 0,
TotalRating NUMBER(16) DEFAULT 0,
AverageRating GENERATED ALWAYS AS (CASE WHEN TotalReviewCount > 0

출처 : 해피캠퍼스