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