DeliveryOracle
테이블 (14)
Comments
- comment_id — INT
- store_id — INT — NOT NULL
- author_id — INT — NOT NULL
- author_name — VARCHAR(20) — NOT NULL
- content — TEXT — NOT NULL
- rating — TINYINT
- visibility_status — TINYINT(1) — NOT NULL
- creation_date — TIMESTAMP
- modification_date — TIMESTAMP
- reply_id — INT
- depth — TINYINT
OrderInformation
- order_id — INT
- customer_id — INT — NOT NULL
- store_id — INT — NOT NULL
- order_details — VARCHAR(255) — NOT NULL
- total_price — INT — NOT NULL
- order_approval_status — TINYINT(1) — NOT NULL
- order_date — TIMESTAMP
- user_x — DECIMAL(15, 12) — NOT NULL
- user_y — DECIMAL(15, 12) — NOT NULL
Reports
- report_id — INT
- comment_id — INT — NOT NULL
- comment_author_id — INT — NOT NULL
- report_status — TINYINT(1) — NOT NULL
- report_text — VARCHAR(100) — NOT NULL
- reporter_id — INT — NOT NULL
- report_date — TIMESTAMP
RiderDelivery
- delivery_id — INT
- order_id — INT — NOT NULL
- store_id — INT — NOT NULL
- store_name — VARCHAR(30) — NOT NULL
- store_owner_email — VARCHAR(30) — NOT NULL
- rider_id — INT — NOT NULL
- distance_to_store — DECIMAL(15, 12) — NOT NULL
- distance_to_user — DECIMAL(15, 12) — NOT NULL
- delivery_price — INT — NOT NULL
- delivery_status — TINYINT(1) — NOT NULL
- store_x — DECIMAL(15, 12) — NOT NULL
- store_y — DECIMAL(15, 12) — NOT NULL
- user_x — DECIMAL(15, 12) — NOT NULL
- user_y — DECIMAL(15, 12) — NOT NULL
- order_date — TIMESTAMP
StoreInformation
- store_id — INT — 기본 키 — NOT NULL
- menu_name — VARCHAR(30) — 기본 키 — NOT NULL
- menu_price — INT — NOT NULL
- menu_image — VARCHAR(255)
- visibility_status — TINYINT(1) — NOT NULL
StoreRegistration
- store_id — INT
- owner_id — INT — NOT NULL
- store_name — VARCHAR(30) — NOT NULL
- store_address — VARCHAR(50) — NOT NULL
- store_description — TEXT
- store_image — VARCHAR(255)
- approval_status — TINYINT(1) — NOT NULL
- approval_date — DATETIME
- modification_date — TIMESTAMP
- store_x — DECIMAL(15, 12) — NOT NULL
- store_y — DECIMAL(15, 12) — NOT NULL
- store_ca — VARCHAR(20) — NOT NULL
StoreRegistrationAudit
- audit_id — INT
- store_id — INT
- owner_id — INT
- store_name — VARCHAR(30)
- store_address — VARCHAR(50)
- store_description — TEXT
- store_image — VARCHAR(100)
- approval_status — TINYINT(1)
- approval_date — DATETIME
- modification_date — TIMESTAMP
- store_x — DECIMAL(15, 12)
- store_y — DECIMAL(15, 12)
- store_ca — VARCHAR(20)
- change_type — ENUM('UPDATE', 'DELETE')
- change_date — TIMESTAMP
StoreReports
- report_id — INT
- order_id — INT — NOT NULL
- store_id — INT — NOT NULL
- report_status — TINYINT(1) — NOT NULL
- report_text — VARCHAR(100) — NOT NULL
- reporter_id — INT — NOT NULL
- report_date — TIMESTAMP
account
- account_id — INT
- owner_id — INT
- owner_name — VARCHAR(10)
- owner_email — VARCHAR(30)
- account_status — TINYINT(1)
- account_amount — INT
- approval_date — TIMESTAMP
- change_date — TIMESTAMP
accountstatus
- num — INT
- account_id — INT
- amount — INT
- type — VARCHAR(10)
- date — TIMESTAMP
rankpoint
- Rating — VARCHAR(20)
- score — int
userinfo_auth
- auth_no — int — 기본 키 — NOT NULL
- user_id — varchar(100) — NOT NULL
- auth — varchar(100) — NOT NULL
visitors
- email — VARCHAR(255) — 기본 키 — NOT NULL
- visit_date — DATE — 기본 키 — NOT NULL
유저 정보 테이블 (UserInformation)
- 유저 번호 (user_id) — INT AUTO_INCREMENT PRIMARY KEY,
- 이메일 (Email) — VARCHAR(30) — NOT NULL
- 비밀번호 (Password) — VARCHAR(255) — NOT NULL
- 이름 (Name) — VARCHAR(10) — NOT NULL
- 등록일 (registration_date) — DATETIME
- 수정일 (modification_date) — DATETIME