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