AWS_팀프로젝트_쇼핑몰

테이블 (6)

authority_tb (Untitled3)

  • authority_id (Key) — int — 기본 키 — NOT NULL
  • user_id (Field) — int
  • role_id (Field2) — int

order_detail_tb (Untitled6)

  • Key — 기본 키 — NOT NULL

order_history_tb (Untitled5)

  • Key — 기본 키 — NOT NULL

order_tb (Untitled4)

  • order_id (Key) — int — 기본 키 — NOT NULL
  • order_detail_id (Field) — int
  • order_status (Field3) — int
  • order_date (Field4) — datetime
  • order_address (Field5) — varchar(100)

role_tb (Untitled2)

  • role_id (Key) — int — 기본 키 — NOT NULL
  • role_name (Field) — varchar(45)

user_id (Untitled)

  • user_id (Key) — int — 기본 키 — NOT NULL
  • authority_id (Field) — int
  • email (Field2) — varchar(45)
  • password (Field8) — varchar(200)
  • name (Field3) — varchar(45)
  • nickname (Field4) — varchar(45)
  • address (Field5) — varchar(100)
  • phone_number (Field6) — varchar(45)
  • order_id (Field9) — int
  • order_history_id (Field7) — int