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