Seouljibsa
Tables (6)
bookmarks
- bookmark_id — BIGINT
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- notice_id — BIGINT — Foreign key → notices.id — NOT NULL
- created_at — DATETIME — NOT NULL
- INDEX — idx_bookmarks_notice_id
notices
- id — BIGINT — Primary key — NOT NULL
- title — VARCHAR(255) — NOT NULL
- category — VARCHAR(50)
- summary — TEXT
- reg_date — DATE
- start_date — DATE
- end_date — DATE
- pdf_url — VARCHAR(1000)
- origin_url — VARCHAR(1000)
- INDEX — idx_notice_period
quiz_options
- id — BIGINT
- question_id — BIGINT — Foreign key → quiz_questions.id — NOT NULL
- option_text — VARCHAR(255) — NOT NULL
- is_correct — TINYINT(1) — NOT NULL
- Field
quiz_questions
- id — BIGINT
- question — VARCHAR(255) — NOT NULL
- explanation — VARCHAR(255)
user_details
- user_id — BIGINT — Foreign key → users.user_id — NOT NULL
- birth_date — DATE
- target_type — ENUM('YOUTH','STUDENT','NEWLYWED','EITHER')
- marriage_status — ENUM('SINGLE','MARRIED','PLANNED')
- child_count — INT
- house_own — ENUM('YES','NO')
- asset — BIGINT
- income — BIGINT
users
- user_id — BIGINT — Primary key — NOT NULL — PK
- auth_type — ENUM('LOCAL', 'GOOGLE', 'KAKAO') — NOT NULL — 가입 경로
- login_id — VARCHAR(50) — 자체 로그인 ID
- provider_id — VARCHAR(255) — 소셜 로그인 ID
- password — VARCHAR(255) — 암호화 비밀번호
- user_name — VARCHAR(50) — NOT NULL — 사용자 이름
- email — VARCHAR(255) — NOT NULL — 이메일
- role — ENUM('USER', 'ADMIN') — NOT NULL
- created_at — TIMESTAMP — NOT NULL
- updated_at — TIMESTAMP — NOT NULL