With U.( Shared Calendar Project)
공유 캘린더 DB설계 초안
테이블 (3)
Calendar Schedule (calendar_schedule)
- UserID (user_id) — CHAR(10) — 외래 키 → calendar table.UserID — NOT NULL
- Title (title) — VARCHAR(100)
- Content (content) — VARCHAR(255)
- Date (date) — Date(10)
- Share (share) — boolean(2)
calendar table (calendar_table)
- UserID (user_id) — CHAR(10) — 외래 키 → user table.UserID — NOT NULL
- Approval (approval) — boolean(2)
user table (user_table)
- UserID (user_id) — CHAR(10) — 기본 키 — NOT NULL
- User Name (user_name) — CHAR(10)
- User Hint (user_hint) — VARCHAR(100)
- User Answer (user_aws) — VARCHAR(150)
- User Password (user_pw) — VARCHAR(10)
- User Password Check (user_pw_ck) — VARCHAR(10)