doldolseo
Tables (10)
crew_board_comment_tbl
- CREW_POST_NO — NUMBER — Foreign key → crew_board_tbl.CREW_POST_NO — NOT NULL — UNIQUE
- COMMENT — 'UNIQUE' — UNIQUE
- _NO — NUMBER — NOT NULL — ID` VARCHAR2 NOT NULL COMMENT 'UNIQUE
- CONTENT — VARCHAR2 — NOT NULL
- W_DATE — DATE — NOT NULL
crew_board_tbl
- CREW_POST_NO — NUMBER — Primary key — NOT NULL — UNIQUE
- CREW_NO — NUMBER — Foreign key → crew_tbl.CREW_NO — NOT NULL — UNIQUE
- ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
- CATEGORY — VARCHAR2 — NOT NULL
- TITLE — VARCHAR2 — NOT NULL
- CONTENT — VARCHAR2 — NOT NULL
- MEMBERLIST — VARCHAR2 — 멤버목록 삽입(id1/id2/...)
- UPLOAD_IMAGE — VARCHAR2
- W_DATE — DATE — NOT NULL
- COUNT — NUMBER — NOT NULL
crew_member_tbl
- CREW_REG_NO — NUMBER — Primary key — NOT NULL — UNIQUE
- CREW_NO — NUMBER — Foreign key → crew_tbl.CREW_NO — NOT NULL — UNIQUE
- MEBER_ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
- STATE — BOOLEAN — NOT NULL — FALSE : 가입대기, TRUE : 가입승인
crew_tbl
- CREW_NO — NUMBER — Primary key — NOT NULL — UNIQUE
- ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
- CREW_NAME — VARCHAR2 — NOT NULL — UNIQUE
- AREALIST — VARCHAR2
- INTRO — VARCHAR2 — NOT NULL
- INTRO_DETAIL — VARCHAR2 — NOT NULL
- RECRUIT — VARCHAR2 — NOT NULL
- QUESTION1 — VARCHAR2 — NOT NULL
- QUESTION2 — VARCHAR2
- QUESTION3 — VARCHAR2 — 가입질문은 최대 3개 까지 생성 가능하게 코딩
- MAIN_IMAGE — VARCHAR2
- C_DATE — DATE — NOT NULL
- GRADE — VARCHAR2 — NOT NULL
- CREW_POINT — NUMBER — NOT NULL
member_tbl
- ID — VARCHAR2 — Primary key — NOT NULL — UNIQUE
- PASSWORD — VARCHAR2 — NOT NULL
- NAME — VARCHAR2 — NOT NULL
- NICKNAME — VARCHAR2 — NOT NULL — UNIQUE
- MEMBER_IMG — VARCHAR2
- BIRTH — DATE — NOT NULL
- GENDER — VARCHAR2 — NOT NULL
- EMAIL — VARCHAR2 — NOT NULL
- PHONE — VARCHAR2
- CRLEADER — CAHR
plan_tbl
- PLAN_NO — NUMBER — Primary key — NOT NULL — UNIQUE
- PLANNER_NO — NUMBER — Foreign key → planner_tbl.PLANNER_NO — NOT NULL
- DATE — DATE — NOT NULL — 날짜-시-분
- NAME — VARCHAR2 — NOT NULL
- INTRO — VARCHAR2
- X — NUMBER — NOT NULL
- Y — NUMBER — NOT NULL
planner_tbl
- PLANNER_NO — NUMBER — Primary key — NOT NULL — UNIQUE
- ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
- TITLE — VARCHAR2 — NOT NULL
- F_DATE — DATE — NOT NULL
- L_DATE — DATE — NOT NULL
- INTRO — VARCHAR2
- W_DATE — DATE — NOT NULL
review_board_comment_tbl
- ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
- COMMENT — 'UNIQUE' — UNIQUE
- _NO — NUMBER — NOT NULL — REVIEW_NO` NUMBER NOT NULL DEFAULT 1 COMMENT 'UNIQUE
- content — VARCHAR2 — NOT NULL
- W_DATE — DATE — NOT NULL
review_board_tbl
- REVIEW_NO — NUMBER — Primary key — NOT NULL — UNIQUE
- ID — VARCHAR2 — Foreign key → member_tbl.ID — NOT NULL — UNIQUE
- AREA_NO — NUMBER — NOT NULL
- TITLE — VARCHAR2 — NOT NULL
- CONTENT — VARCHAR2 — NOT NULL
- COUSE_IMG — VARCHAR2
- UPLOAD_IMG — VARCHAR2
- W_DATE — DATE — NOT NULL
- HIT — NUMBER — NOT NULL
seoul_area_tbl
- NAME — VARCHAR2 — Primary key — NOT NULL — title
- ADDRESS — VARCHAR2 — addr1
- SIGUNGU — NUMBER — NOT NULL — sigungucode
- ZIPCODE — NUMBER — zipcode
- TEL — VARCHAR2 — tel
- X — NUMBER — mapx
- Y — NUMBER — mapy
- IMAGE1 — VARCHAR2 — firstimage
- IMAGE2 — VARCHAR2 — firstimage2
- CONTENTID — NUMBER — NOT NULL — contentid
- CONTENTTYPE — number — NOT NULL — contenttypeid