Order&Dailys

Tables (11)

Comment (댓글)

  • id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • comments (Key2) — List — Foreign key → Todo.user_id — NOT NULL
  • contents (Field) — Varchar(255)
  • createdAt (Field2) — DATETIME
  • modifiedAt (Field3) — DATETIME

Coupon (쿠폰)

  • id (기본키) — Long — Primary key — NOT NULL
  • totalquantity (총주문량) — BigInt
  • issuedCount (주문횟수) — BigInt
  • version (버전락) — BigInt

CouponStat (쿠폰상태)

  • id (기본키) — Long — Primary key — NOT NULL
  • couponId (쿠폰ID) — Long
  • totalIssued (총주문) — Long

Log (기록)

  • id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • log (Field)
  • createdAt (Field2) — DATETIME
  • modifiedAt (Field3) — DATETIME

Manager (관리자)

  • id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • user_id (Key2) — FK — Foreign key → User.id — NOT NULL
  • todo_id (Key3) — FK — Foreign key → Todo.id — NOT NULL

Order (주문)

  • id (기본키) — Long — Primary key — NOT NULL
  • user_id (사용자ID) — Long — Foreign key → User.id — NOT NULL

OrderItem (주문품목)

  • id (기본키) — Long — Primary key — NOT NULL
  • order_id (주문목록) — Long — Foreign key → User.id — NOT NULL
  • user_id (사용자목록) — Long — Foreign key → Order.id — NOT NULL
  • product_id (제품ID) — Long — Foreign key → Product.id — NOT NULL
  • quantity (수량) — BigInt

Product (제품)

  • id (기본키) — Long — Primary key — NOT NULL
  • name (이름) — Varcahr
  • price (가격) — Varcahr

Todo (할일)

  • id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • user_id (Key2) — FK — Foreign key → User.id — NOT NULL
  • title (Field) — Varchar(255)
  • contents (Field2) — Varchar(255)
  • weather (Field3) — Varchar(255)
  • createdAt (Field4) — DATETIME
  • modifiedAt (Field5) — DATETIME

User (사용자)

  • id (기본키) — Long — Primary key — NOT NULL
  • name (이름) — VARCHAR

User (유저)

  • id (Key) — AUTO_INCREMENT — Primary key — NOT NULL
  • email (unique) — Varchar(255)
  • nickname (Field2) — Varchar(255)
  • password (Field) — Varchar(255)
  • userRole (Field3) — UserRole
  • imageUrl (Field4) — Varcahr(255)
  • createdAt (Field5) — DATETIME
  • modifiedAt (Field6) — DATETIME