eyevel

Tables (8)

area (Untitled2)

  • no (Key) — int — Primary key — NOT NULL — auto_increment
  • name (Field) — varchar(255)
  • contents (Field2) — varchar(1000)
  • link_url (Field3) — varchar(1000)
  • continent (Field7) — varchar(20)
  • dir_X (Field8) — int
  • dir_Y (Field9) — int
  • lon (Field4) — float
  • lat (Field5) — float
  • id (Field6) — int

area_img (Untitled6)

  • area_no (Key) — int — Foreign key → area.no — NOT NULL
  • weather (Field) — varchar(10)
  • img (Field2) — varchar(255)

board (Untitled5)

  • no (Key) — int — Primary key — NOT NULL — auto_increment
  • category (Field) — int — NOT NULL
  • is_private (Field2) — int
  • member_id (Key2) — varchar(20) — Foreign key → member.id — NOT NULL
  • title (Field4) — varchar(255)
  • contents (Field5) — varchar(1000)
  • reg_date (Field6) — datetime
  • hits (Field3) — int
  • heart (Field7) — int
  • admin_check (Field8) — int

boardComment (Untitled8)

  • no (Key) — int — Primary key — NOT NULL
  • board_no (Key2) — int — Foreign key → board.no — NOT NULL — auto_increment
  • comment (Field) — varchar(1000)
  • member_id (Key3) — varchar(20) — Foreign key → member.id — NOT NULL
  • reg_datetime (Field2) — datetime

boardlike (Untitled7)

  • boar_no (Key) — int — Foreign key → board.no — NOT NULL — auto_increment
  • member_id (Key2) — varchar(20) — Foreign key → member.id — NOT NULL

comment (Untitled4)

  • no (Key) — int — Primary key — NOT NULL — auto_increment
  • member_id (Key2) — varchar(20) — Foreign key → member.id — NOT NULL
  • area_no (Key3) — int — Foreign key → area.no — NOT NULL
  • reg_datetime (Field) — datetime
  • contents (Field3) — varchar(1000)

member (Untitled)

  • id (Key) — varchar(20) — Primary key — NOT NULL
  • pw (Field) — varchar(20)
  • name (Field2) — varchar(20)
  • email (Field3) — varchar(255)
  • img (Field4) — varchar(255)

zzim (Untitled3)

  • area_no (Key) — int — Foreign key → area.no — NOT NULL
  • member_id (Key2) — varchar(20) — Foreign key → member.id — NOT NULL