LINKPLUS
Tables (11)
FTPTB
- FILE_ID — VARCHAR(20) — Primary key — NOT NULL
- FILE_NM — VARCHAR(100)
- FILE_PATH — VARCHAR(100)
- FILE_EXTENSION — VARCHAR(5)
- FILE_DIV — VARCHAR(5)
- FILE_BLOB — BLOB
- FILE_SEQ — NUMBER
- FILE_SAVE — VARCHAR(100)
comment_log
- date_edit — date — NOT NULL
- comment_log — long — NOT NULL
commenttb
- comment_number — number(20) — Primary key — NOT NULL
- id_number(댓글작성자) (id_number) — number(20) — NOT NULL
- comment_text — long
- date_create — date — NOT NULL
- date_edit — date
- content_id — number(20) — Foreign key → contenttb.content_id — NOT NULL
content_file
- file_id — number(20) — Foreign key → filetb.file_id — NOT NULL
- content_id — number(20) — Foreign key → contenttb.content_id — NOT NULL
- id_number — number(20) — Foreign key → contenttb.id_number — NOT NULL
contenttb
- content_id — number(20) — Primary key — NOT NULL
- id_number — number(20) — Foreign key → usertb.id_number — NOT NULL
- category — varchar(20) — NOT NULL
- content_title — varchar(40) — NOT NULL
- content_text — long
- view_count — number(20) — NOT NULL
- vote_count — number(20) — NOT NULL
- date_create — date — NOT NULL
- date_edit (date_edite) — date
- destination_id — number(20) — Foreign key → destination.destination_id
contenttb_log
- content_id — number(20) — Foreign key → contenttb.content_id — NOT NULL
- id_number — number(20) — Foreign key → contenttb.id_number — NOT NULL
- date_edit — date — NOT NULL
- content_log — long — NOT NULL
desti_file
- destination_id — number(20) — Foreign key → destination.destination_id — NOT NULL
- file_id — number(20) — Foreign key → filetb.file_id — NOT NULL
destination
- destination_id — number(20) — Primary key — NOT NULL
- destination_name — varchar(20) — NOT NULL
- destination_short — varchar(255) — NOT NULL
- destination_text — long
- destination_vote — number(20) — NOT NULL
- destination_location — varchar(30)
- destination_GPS — varchar(20)
filetb
- file_id — number(20) — Primary key — NOT NULL
- size_file — number(20)
- title — varchar(20) — NOT NULL
- height_file — number(20)
- width_file — number(20)
- type_file — varchar(5) — NOT NULL
- link — long
- file_blob — blob
plannertb
- id_number — number(20) — Foreign key → usertb.id_number — NOT NULL
- destination_id — number(20) — Foreign key → destination.destination_id — NOT NULL
- date_start — varchar
- date_end — varchar
- transport — varchar
- destination_GPS — int
usertb
- id_number — number(20) — Primary key — NOT NULL
- ID (id_id) — varchar(20) — NOT NULL
- Password (password_id) — varchar(20) — NOT NULL
- email (email_id) — varchar(20) — NOT NULL
- date_create — date — NOT NULL
- del_id — int
- user_name — varchar(10) — NOT NULL
- nick_name — varchar(20) — NOT NULL
- phone_number (tel_id) — varchar(20) — NOT NULL
- admin_id (adimin_id) — int — NOT NULL