lnfo

테이블 (7)

게시판 (Board)

  • board_id (Key) — long — 기본 키 — NOT NULL
  • userid (Key3) — long — 외래 키 → 유저.user_id — NOT NULL — user id
  • title (Field) — String
  • content (Field2) — String
  • category_name (Field3) — String
  • creared_time (Field4) — DateTime
  • post_image (Field5) — String

댓글 (comment)

  • comment_id (Key) — long — 기본 키 — NOT NULL
  • content (Field) — String
  • created_time (Field2) — DateTime
  • board_id (Key2) — long — 외래 키 → 게시판.board_id — NOT NULL
  • userid (Key3) — long — 외래 키 → 유저.user_id — NOT NULL — user id
  • parent_id (Key4) — long — 외래 키 → 댓글.comment_id — NOT NULL

문화 (culture)

  • culture_id (Key) — long — 기본 키 — NOT NULL
  • title (Field) — String
  • img (Field2) — String
  • price (Field3) — String
  • startDate (Field4) — String
  • endDate (Field5) — String
  • place (Field6) — String
  • area (Field7) — String
  • discountRate (Field8) — String
  • userid (Key2) — long — 외래 키 → 유저.user_id — NOT NULL — user id

알림 (Alarm)

  • alarm_id (Key) — long — 기본 키 — NOT NULL
  • type (Field) — String
  • content (Field2) — String — 어떤 알람인가?
  • is_read (Field3) — Boolean
  • created_time (Field4) — DateTime
  • userid (Key3) — long — 외래 키 → 유저.user_id — NOT NULL — user id
  • board_id (Key4) — long — 외래 키 → 게시판.board_id — NOT NULL
  • comment_id (Key5) — long — 외래 키 → 댓글.comment_id — NOT NULL
  • like_id (Key6) — long — 외래 키 → 좋아요.like_id — NOT NULL

유저 (User)

  • user_id (Key) — long — 기본 키 — NOT NULL — user id
  • Email (Field) — String
  • Password (Field2) — String
  • NickName (Field3) — String
  • IndependentType (Field4) — enum
  • phone_number (Field5) — String

좋아요 (Like)

  • like_id (Key) — long — 기본 키 — NOT NULL
  • userid (Key2) — long — 외래 키 → 유저.user_id — NOT NULL — user id
  • board_id (Key3) — long — 외래 키 → 게시판.board_id — NOT NULL

주택청약 (apartment)

  • apartment_id (Key) — long — 기본 키 — NOT NULL
  • userid (Key2) — long — 외래 키 → 유저.user_id — NOT NULL — user id
  • pblanc_no (Field) — String
  • house_nm (Field2) — String
  • house_dtl_secd_nm (Field3) — String
  • rent_secd_nm (Field4) — String
  • subscrpt_area_code_nm (Field5) — String
  • hssply_adres (Field7) — String
  • tot_suply_hshldco (Field8) — String
  • rcept_bgnde (Field9) — String
  • rcept_endde (Field10) — String
  • spsply_rcept_bgnde (Field11) — String
  • spsply_rcept_endde (Field12) — String
  • subscrpt_rcept_bgnde (Field13) — String
  • subscrpt_rcept_endde (Field14) — String
  • przwner_presnatn_de (Field15) — String
  • cntrct_cncls_bgnde (Field6) — String
  • cntrct_cncls_endde (Field16) — String