CH3. SheduleDevelop
Tables (3)
comments (Untitled3)
- id (PK) — BIGINT — Primary key — NOT NULL
- contents (내용) — VARCHAR(200)
- created_at (작성일) — DateTime(6)
- modified_at (수정일) — DateTime(6)
- user_id (FK1) — BIGINT — Foreign key → users.id — NOT NULL
- schedule_id (FK2) — BIGINT — Foreign key → schedules.id — NOT NULL
schedules (Untitled2)
- id (PK) — BIGINT — Primary key — NOT NULL
- title (제목) — VARCHAR(50)
- contents (내용) — VARCHAR(200)
- created_at (작성일) — DateTime(6)
- modified_at (수정일) — DateTime(6)
- user_id (FK) — BIGINT — Foreign key → users.id — NOT NULL
users (Untitled)
- id (PK) — BIGINT — Primary key — NOT NULL
- userName (유저명) — VARCHAR(10)
- email (이메일) — VARCHAR(100)
- password (비밀번호) — VARCHAR(100)
- created_at (작성일) — DateTime(6)
- modified_at (수정일) — DateTime(6)