board

Tables (5)

board (게시판)

  • id (Key) — Primary key — NOT NULL
  • name (Field)
  • content (Field2)
  • reg_id (Field3)
  • reg_date (Field4)
  • upd_date (Field5)
  • upd_id (Field6)
  • db_status (Field8)
  • db_status (Field7)
  • board_type (Field9) — String

img (이미지)

  • id (Key) — Primary key — NOT NULL
  • origin_name (Field)
  • uuid_name (Field2)
  • path (Field3)
  • reg_date (Field6)
  • upd_date (Field7)
  • post_id (Key2) — Foreign key → post.Key — NOT NULL

post (게시물)

  • Key — Primary key — NOT NULL
  • title (Field)
  • content (Field2)
  • non_mem_nick (Field3)
  • non_mem_pwd (Field4)
  • upd_date (Field7)
  • img_id (Field8)
  • db_status (Field9)
  • reg_id (Key2) — Foreign key → user.id — NOT NULL
  • board_id (Key3) — Foreign key → board.id — NOT NULL
  • db_status (Field5)

reply (댓글)

  • id (Key) — Primary key — NOT NULL
  • non_mem_nick (Field)
  • non_mem_pwd (Field2)
  • reg_date (Field5)
  • upd_date (Field6)
  • post_id (Key2) — Foreign key → post.Key — NOT NULL
  • db_status (Field3)

user (유저)

  • id (Key) — Primary key — NOT NULL
  • account_id (Field)
  • password (Field2)
  • nickname (Field3)
  • mail (Field4)
  • reg_date (Field6)
  • upd_date (Field7)
  • db_status (Field5)