platform-project
테이블 (13)
AuthToken (Untitled7)
- id (Key) — bigint — 기본 키 — NOT NULL
- access_token (Field) — varchar(4000)
- access_token_expires (Field2) — datetime
- refresh_token (Field3) — varchar(4000)
- refresh_token_expires (Field4) — datetime
- valid (Field5) — tinyint
Authorites (Untitled8)
- authority_name (Key) — varchar(50) — 기본 키 — NOT NULL
Category (CopyOfUntitled4)
- id (Key) — bigint — 기본 키 — NOT NULL
- category_name (Field) — varchar(500)
- parent_id (Field2) — bigint
- Field3
Category_item (Untitled6)
- category_id (Key) — bigint — 외래 키 → Category.id — NOT NULL
- item_id (Key2) — bigint — 외래 키 → Item.id — NOT NULL
Coupon (Untitled5)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
- name (Field) — varchar(500)
- created_date (Field2) — datetime
- removed_date (Field3) — datetime
- discount_rate (Field5) — int
- valid (Field4) — tinyint
- used (Field6) — tinyint
- Field7
Delivery (Untitled11)
- id (Key) — bigint — 기본 키 — NOT NULL
- address (Field) — varchar(500)
- status (Field2) — varchar(50)
- created_date (Field3) — datetime
- updated_date (Field4) — datetime
- Field5
DeviceToken (Untitled12)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
- device_token (Field) — varchar(255)
- valid (Field2) — tinyint
Item (Untitled3)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(100)
- price (Field2) — int
- brand (Field3) — varchar(200)
- stock_quantity (Field4) — int
- item_image (Field5) — varchar(?)
- Field6
Order (Untitled2)
- id (Key) — bigint — 기본 키 — NOT NULL
- user_id (Key2) — bigint — 외래 키 → User.id — NOT NULL
- delivery_id (Key3) — bigint — 외래 키 → Delivery.id — NOT NULL
- order_date (Field2) — datetime
- status (Field3) — varchar(50)
- order_item_id (Field) — bigint
- created_date (Field4) — datetime
- updated_date (Field5) — datetime
- Field6
OrderItems (Untitled9)
- id (Key) — bigint — 기본 키 — NOT NULL
- order_id (Key2) — bigint — 외래 키 → Order.id — NOT NULL
- item_id (Key3) — bigint — 외래 키 → Item.id — NOT NULL
- count (Field) — int
- Field2
User (Untitled)
- id (Key) — bigint — 기본 키 — NOT NULL
- token_id (Key2) — bigint — 외래 키 → AuthToken.id — NOT NULL
- email (Field) — varchar(255)
- name (Field2) — varchar(255)
- nickname (Field3) — varchar(255)
- user_type (Field15) — varchar(40)
- tel_num (Field4) — varchar(45)
- address (Field5) — varchar(500)
- zip_code (Field9) — varchar(45)
- profile_image (Field10) — varchar(500)
- sns_type (Field14) — varchar(50)
- sns_key (Field8) — varchar(255)
- allow_email (Field6) — tinyint
- allow_push (Field7) — tinyint
- authenticated_email (Field11) — tinyint
- authenticated_phone (Field12) — tinyint
- activated (Field13) — tinyint
- birthday (Field18) — datetime
- created_date (Field16) — datetime
- updated_date (Field17) — datetime
- gender (Field19) — char(2)
- Field20
User_Authorities (Untitled10)
- user_id (Key) — bigint — 외래 키 → User.id — NOT NULL
- authority_name (Key2) — varchar(50) — 외래 키 → Authorites.authority_name — NOT NULL
이용약관 (Untitled4)
- id (Key) — bigint — 기본 키 — NOT NULL
- name (Field) — varchar(100)
- contents (Field2) — varchar(5000)
- Field3