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