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