goyang
Tables (18)
ADOPT
- adopt_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER — NOT NULL
- a_title — VARCHAR2(255) — NOT NULL
- a_content — LONGTEXT — NOT NULL
- a_view_cnt — NUMBER
- c_name — VARCHAR2(50) — NOT NULL
- c_type — VARCHAR2(50) — NOT NULL
- c_gender — VARCHAR2(50) — NOT NULL
- c_weight — VARCHAR2(50) — NOT NULL
- c_age — VARCHAR2(50) — NOT NULL
- c_vac — VARCHAR2(50) — NOT NULL
- c_neu — VARCHAR2(50) — NOT NULL
- c_adopted_yn — VARCHAR2(50)
ADOPT_IMAGE
- adopt_id — NUMBER — Primary key — NOT NULL
- img_id — NUMBER — Primary key — NOT NULL
- img_original_file — VARCHAR2(255) — NOT NULL
- img_stored_file — VARCHAR2(255) — NOT NULL
APPLY
- adopt_id — NUMBER — Primary key — NOT NULL
- apply_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER
- a_name — VARCHAR2(50)
- a_age — VARCHAR2(50)
- a_gender — VARCHAR2(50)
- a_address — varchar2(100)
- a_phone — varchar2(13)
- a_job — varchar2(13)
- a_marry — VARCHAR2(13)
- a_ask1 — VARCHAR2(4000)
- a_ask2 — VARCHAR2(4000)
- a_ask3 — VARCHAR2(4000)
- a_ask4 — VARCHAR2(4000)
- a_ask5 — VARCHAR2(4000)
- a_ask6 — VARCHAR2(4000)
- a_ask7 — VARCHAR2(4000)
BOARD
- board_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER — NOT NULL
- b_title — VARCHAR2(255) — NOT NULL
- b_content — VARCHAR2(4000) — NOT NULL
- b_view_cnt — NUMBER
- b_like_cnt — NUMBER
- b_common_board — VARCHAR2(255) — NOT NULL
- b_ref — NUMBER
- b_re_step — NUMBER
- b_re_level — NUMBER
- create_date — DATE — NOT NULL
- modified_date — DATE — NOT NULL
BOD_IMG
- board_id — NUMBER — Primary key — NOT NULL
- img_id — NUMBER — Primary key — NOT NULL
- img_original_file — VARCHAR2(255) — NOT NULL
- img_stored_file — VARCHAR2(255) — NOT NULL
CART
- member_id — NUMBER — Primary key — NOT NULL
- product_id — NUMBER — Primary key — NOT NULL
- create_date — DATE
- modified_date — DATE
CHATROOM
- room_id — NUMBER — Primary key — NOT NULL
- member_id1 — NUMBER — NOT NULL
- member_id2 — NUMBER — NOT NULL
- create_date — DATE
CHAT_MESSAGE
- room_id — NUMBER — Primary key — NOT NULL
- message_id — NUMBER — Primary key — NOT NULL
- create_date — DATE
- owner_id — VARCHAR2(1)
COMMON
- bcd — VARCHAR2(20) — Primary key — NOT NULL
- mcd — NUMBER(3) — Primary key — NOT NULL
- word — VARCHAR2(255) — NOT NULL
- create_date — DATE — NOT NULL
G_NOTICE
- g_notice_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER
- g_common_csBoard — VARCHAR2(255) — NOT NULL
- g_notice_title — VARCHAR2(255) — NOT NULL
- g_notice_content — VARCHAR2(4000) — NOT NULL
- create_date — DATE — NOT NULL
- modified_date — DATE — NOT NULL
G_NOT_IMG
- g_notice_id — NUMBER — Primary key — NOT NULL
- img_id — NUMBER — Primary key — NOT NULL
- img_original_file — VARCHAR2(255) — NOT NULL
- img_stored_file — VARCHAR2(255) — NOT NULL
G_WRITING
- g_writing_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER — NOT NULL
- g_title — VARCHAR2(255) — NOT NULL
- g_content — VARCHAR2(4000) — NOT NULL
- g_passwd — VARCHAR2(255) — NOT NULL
- g_view_cnt — NUMBER
- g_reply_yn — CHAR(1) — NOT NULL
- g_reply_content — VARCHAR2(4000)
- create_date — DATE — NOT NULL
- modified_date — DATE — NOT NULL
G_WRT_IMG
- g_writing_id — NUMBER — Primary key — NOT NULL
- img_id — NUMBER — Primary key — NOT NULL
- img_original_file — VARCHAR2(255) — NOT NULL
- img_stored_file — VARCHAR2(255) — NOT NULL
MEMBER
- member_id — NUMBER — Primary key — NOT NULL
- m_email — VARCHAR2(40) — NOT NULL
- m_nickname — VARCHAR2(255) — NOT NULL
- m_passwd — VARCHAR2(255) — NOT NULL
- m_name — VARCHAR2(50) — NOT NULL
- m_phone — VARCHAR2(30) — NOT NULL
- m_common_role — VARCHAR2(255) — NOT NULL
- m_address — VARCHAR2(255) — NOT NULL
- m_point — NUMBER
- m_img_context — VARCHAR2(255) — NOT NULL
- m_img_original_file — VARCHAR2(255) — NOT NULL
- m_img_stored_file — VARCHAR2(255) — NOT NULL
- create_date — DATE — NOT NULL
- modified_date — DATE — NOT NULL
POINT
- point_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER
- point_type — VARCHAR2(30)
- point_history — VARCHAR2(100)
- create_date — DATE
PRODUCT
- product_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER
- p_name — VARCHAR2(50)
- p_status — VARCHAR2(4000)
- p_content — VARCHAR2(100)
- p_type — VARCHAR2(30)
- p_loc — VARCHAR2(50)
- create_date — DATE
- modified_date — DATE
PRODUCT_IMG
- product_id — NUMBER — Primary key — NOT NULL
- img_id — NUMBER — Primary key — NOT NULL
- IMG_ORIGINAL_FILE — VARCHAR2(255)
- IMG_STORED_FILE — VARCHAR2(255)
WARNING
- w_id — NUMBER — Primary key — NOT NULL
- member_id — NUMBER
- w_common_warning — VARCHAR2(4000)
- w_cnt — NUMBER
- create_date — DATE — NOT NULL
- modified_date — DATE — NOT NULL