프로젝트
테이블 (8)
bucketList
- bucket_id — INT
- bucket_text — VARCHAR(255) — NOT NULL
- isCompleted — BOOLEAN — NOT NULL
- check_id — INT
calendar
- schedule_id — INTEGER
- schedule_text — TEXT
- schedule_date — DATE
chat
- message_id — INTEGER
- room_id — VARCHAR(10)
- Message_text — VARCHAR(100)
- user_id — VARCHAR(50)
- MessageTime — DATETIME
couple_connection_check_for_s
- check_id — INTEGER
- user_id1 — VARCHAR(50)
- user_id2 — VARCHAR(50)
invite_codes
- code_id — INTEGER
- user_id — VARCHAR(50)
- code — VARCHAR(255)
picture
- image_id — INTEGER
- image_uri — VARCHAR(255) — NOT NULL
- image_region — VARCHAR(100)
postInfo
- post_id — INTEGER
- user_id — VARCHAR(50)
- check_id — INTEGER
- postdate — DATE
- title — VARCHAR(255)
- content — TEXT
- img — TEXT
userInfo
- id — VARCHAR(50)
- username — VARCHAR(20)
- pw — VARCHAR(255)
- birthday — DATE
- meetingDay — DATE
- blood_type — VARCHAR(5)
- user_image — TEXT