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