AWS_팀프로젝트_쇼핑몰
테이블 (6)
authority_tb (Untitled3)
- authority_id (Key) — int — 기본 키 — NOT NULL
- user_id (Field) — int
- role_id (Field2) — int
order_detail_tb (Untitled6)
order_history_tb (Untitled5)
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